package com.atguigu.gmall.publisher.mapper;

import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;

/**
 * @author Felix
 * @date 2023/7/19
 * 交易域统计mapper接口
 */
public interface TradeStatsMapper {
    //获取某一天总交易额
    @Select("select sum(original_amount) order_amount\n" +
            "from dws_trade_sku_order_window\n" +
            "         partition (par#{date})")
    BigDecimal selectGMV(Integer date);
}
